Release 10.1A: OpenEdge Development:
AppBuilder

Example: assigning a new sales rep

This example illustrates how to use a SmartSelect instance to update the Sales-Rep field in a Customer record. The tables it uses are found in the sports2000 database.

To use a SmartSelect instance to update the Sales-Rep field in a Customer record (agree to all Advisor suggestions for links):

Create a SmartWindow as the application workspace. Save it.
Create the SmartDataObject master that will pump the Customer records. Choose the Customer table. Use only the Name, Address, City, and Sales-Rep fields from the Customer table. Save the master:



Place into the application workspace an instance of the Customer SmartDataObject you just created:



Create the SmartDataObject master that will feed the SmartSelect field. Choose the Salesrep table. Use only the Sales-Rep field from that table. Save the master:



Create the SmartDataViewer master that will display the Customer records. Include all four of the fields. Save the master, but leave its workspace open:



Place an instance of the Sales-Rep SmartDataObject into the master SmartDataViewer workspace:



Replace the Sales-Rep field in the SmartDataViewer with a SmartSelect instance. Resize the instance for cosmetic reasons:



Save the changes in the SmartDataViewer. Place an instance of the SmartDataViewer into application workspace:



Place Navigation and Update SmartPanels into the application workspace:



Run the workspace. You should be able to assign a new sales rep to any account by choosing from the combo box: